package com.dingding.service.account.core.special.sql;

/**
 * 
 * @ClassName: SpecialDepositAccountSQL 
 * @Description: 专车提现状态SQL类
 * @author YHQ
 * @date 2016年12月22日 下午4:03:11
 * @since V2.6.3
 * 
 */
public class SpecialDepositAccountSQL {

	/**
	 * 
	 * @author YHQ
	 * @Description: 根据专车用户Id删除提现账户
	 * 
	 */
	public static final String DELETE_SPECIAL_DEPOSIT_ACCOUNT = "UPDATE dd_special_deposit_account SET depositAccountStatus = 2 WHERE depositAccountId = ? AND specialUserId = ?";
	
	/**
	 * 
	 * @author YHQ
	 * @Description: 根据专车用户id获取提现账户列表
	 */
	public static final String GET_SPECIAL_DEPOSIT_ACCOUNT_LIST = "SELECT d.depositAccountId,d.depositAccount,d.depositAccountName FROM dd_special_deposit_account d WHERE d.specialUserId = ? AND d.depositAccountStatus = 1";
	
	/**
	 * 
	 * @author YHQ
	 * @Description: 根据专车用户id获取全部提现账户列表
	 */
	public static final String GET_ALL_SPECIAL_DEPOSIT_ACCOUNT_LIST = "SELECT depositAccountId, specialUserId, depositAccount, depositAccountName, createTime, depositAccountStatus FROM dd_special_deposit_account WHERE specialUserId = ? ";
	
	
}
